| SaScheduleStipendsWork |
| Logical Entity Name | SaScheduleStipendsWork |
| Default Table Name | SaScheduleStipendsWork |
| Physical Only | NO |
| Definition | |
| Note |
| SaScheduleStipendsWork Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
SaScheduleStipendsWorkID |
char(10) | NO | ||
| AwardYear | char(10) | YES | ||
| ScheduledDate | char(10) | YES | ||
| StudGroupCodeList | char(10) | YES | ||
| CampusCodeList | char(10) | YES | ||
| ProgramCodeList | char(10) | YES | ||
| PVCodeList | char(10) | YES | ||
| SchoolStatusCodeList | char(10) | YES | ||
| TransDateFrom | char(10) | YES | ||
| TransDateTo | char(10) | YES | ||
| StartDateFrom | char(10) | YES | ||
| StartDateTo | char(10) | YES | ||
| SyCampusID | char(10) | YES | ||
| CampusName | char(10) | YES | ||
| SyStudentID | char(10) | YES | ||
| StudentName | char(10) | YES | ||
| Stunum | char(10) | YES | ||
| FaFundSourceCode | char(10) | YES | ||
| FaFundSourceName | char(10) | YES | ||
| AySeq | char(10) | YES | ||
| PPSeq | char(10) | YES | ||
| Term | char(10) | YES | ||
| AdTermID | char(10) | YES | ||
| AdEnrollID | char(10) | YES | ||
| FaStudentAYID | char(10) | YES | ||
| FaStudentAidID | char(10) | YES | ||
| FaFundSourceID | char(10) | YES | ||
| FaStudentAYPaymentPeriodID | char(10) | YES | ||
| SaTransID | char(10) | YES | ||
| SaStipendID | char(10) | YES | ||
| StipendAmt | char(10) | YES | ||
| OriginalStipendAmt | char(10) | YES | ||
| PackagedAmount | char(10) | YES | ||
| AYInstitutionalCharges | char(10) | YES | ||
| AyAmountSchedForyear | char(10) | YES | ||
| LimitByPackagedAmount | char(10) | NO | ||
| PreventByInstCharges | char(10) | NO | ||
| StipendAddrType | char(10) | YES | ||
| StipendAddrID | char(10) | YES | ||
| PayeeName | char(10) | YES | ||
| IsACHEligible | char(10) | NO | ||
| ReturnMethod | char(10) | YES | ||
| ReturnMethodCode | char(10) | YES | ||
| IsProceed | char(10) | NO | ||
| BatchID | char(10) | YES | ||
| StaffName | char(10) | YES | ||
| UserId | char(10) | NO | ||
| DateAdded | char(10) | NO | ||
| DateLstMod | char(10) | NO | ||
| ts | char(10) | NO |
| SaScheduleStipendsWork Primary and Unique Keys |
| Key Name | Key Type | Keys |
| PK_SaScheduleStipendsWorkID | PrimaryKey | SaScheduleStipendsWorkID |
| SaScheduleStipendsWork Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| SaScheduleStipendsWork Check Constraints |
| Check Constraint Name | CheckConstraint |